package com.tangula.web.kashine.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import com.tangula.web.kashine.entity.SendMoneyFoem;

@Repository
public interface SendMoneyFoemRepository extends JpaRepository<SendMoneyFoem, String>{
	@Query(nativeQuery=true,value="SELECT id,t.send_date AS send_time,t.history_des AS send_desc,t.money AS cost FROM t_history t WHERE t.send_date  BETWEEN :start AND :end AND t.user_id = :studentId")
	List<SendMoneyFoem> loadStudentHistory(@Param("studentId")String condition,@Param("start") String string, @Param("end")String string2);

}
